A Fun Prize at the PASS Data Community Summit
I had a briefing for the 2026 PASS Data Community Summit, which is just a couple of weeks away. Amongst a bunch of admin type stuff, there was a...
2026-10-27
22 reads
I had a briefing for the 2026 PASS Data Community Summit, which is just a couple of weeks away. Amongst a bunch of admin type stuff, there was a...
2026-10-27
22 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8 million Hacker News articles that that I used for my talk on SQL Server-based vector...
2026-10-26 (first published: 2026-10-19)
174 reads
Founded in 2014 by three data enthusiasts, Joyful Craftsmen has grown into an international Data & AI company. Explore our journey, the principles behind our work, and the next...
2026-10-26
24 reads
If you are migrating a data warehouse, there is a question worth asking before you start: should you recreate the existing solution on the new platform, or use the...
2026-10-26 (first published: 2026-10-22)
1,168 reads
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is one of those technologies that I want to understand better. As AI becomes part of...
2026-10-23
39 reads
I’m back from a great vacation. I had the chance to visit two new countries (for me and my wife) and many new cities as we cruised around the...
2026-10-23 (first published: 2026-10-22)
1,301 reads
“What exactly did it do on my server?” is the first question a DBA should ask about any AI agent. AgentDBA answers it from its own records: every decision...
2026-10-23 (first published: 2026-10-09)
303 reads
How to Clear the SSMS Cache (SSMS 21 and Later)
Updated for SSMS 21 and later: This is a new, rewritten version of my earlier article...
2026-10-21 (first published: 2026-10-10)
488 reads
You can find the slides and SQL scripts for my session “Spice up your SQL – Intro to window functions” at GitHub.
The post dataMinds Connect 2026 – Slides &...
2026-10-19 (first published: 2026-10-12)
813 reads
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But why keep this important visual warning at the bottom of the screen? In this post,...
2026-10-14 (first published: 2026-10-05)
553 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers